#Copyright (c) 2025, Alibaba Cloud and its affiliates;
#Licensed under the Apache License, Version 2.0 (the "License");
#you may not use this file except in compliance with the License.
#You may obtain a copy of the License at

#   http://www.apache.org/licenses/LICENSE-2.0

#Unless required by applicable law or agreed to in writing, software
#distributed under the License is distributed on an "AS IS" BASIS,
#WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#See the License for the specific language governing permissions and
#limitations under the License.


import os
import sys
import sqlite3

connect = sqlite3.connect('sqlite.db')
cur = connect.cursor()
print('--select --table <table> \n' \
       '--delete --table <table> <id>')
print('args:%s' % sys.argv)

if len(sys.argv) == 4 and sys.argv[1] == '--select' and sys.argv[2] == '--table':
    sql = 'select * from %s' % sys.argv[3]
    cur.execute(sql)
    val = cur.fetchall()
    for v in val:
        print(v)

if len(sys.argv) == 5 and sys.argv[1] == '--delete' and sys.argv[2] == '--table':
    sql = 'delete from %s where id=%s' % (sys.argv[3], sys.argv[4])
    cur.execute(sql)
    connect.commit()

cur.close()
connect.close()